Create ODS Layer Database
The following steps will help you to create an ODS database.
- Open Microsoft SQL Server Management Studio.
- Right Click on Database ==> Click on New Database.
- New Database dialog box appears ==> Then, give a name for your new database.
- Click Ok to create a new database.
- Click on the plus sign next to the database on object explorer ==> Located newly created database. If you don't see the newly created database, then Right Click on database ==> Click on refresh from the popup dialog box.

*Create Dictionary Tables in ODS Database
Download the SQL file attached above 
- Locate the downloaded file and double click to open it. It will open in Microsoft SQL Server management studio.
- Click Execute to create the following tables.
Dictionary_Incident_Location
Dictionary_Incident_Place
Dictionary_Shooter
Dictionary_Shooter_History_Of_Mental_Illness
dbo].[Dictionary_Shooter_Status
dbo].[Dictionary_Shooters_Motive
Dictionary_Trageted_Victim
Dictionary_Weapons
tbl_Mass_Shooting_ODS


https://www.youtube.com/watch?v=5nfHmh8NsHw&t=179s